SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

/*
----------------------------------------------------------------------------------------------------

-- Created By:  ()
-- Purpose: Select records from the Setting table through an index
----------------------------------------------------------------------------------------------------
*/


CREATE PROCEDURE dbo.Setting_GetBySettingName
(

	@SettingName nvarchar (50)  
)
AS


				SELECT
					[SettingName],
					[SettingValue],
					[DataType],
					[Description]
				FROM
					[dbo].[Setting]
				WHERE
					[SettingName] = @SettingName
				SELECT @@ROWCOUNT
					
			

GO
